Create New Project in SSIS 10

Create a New Project in SSIS

Now open your SQL Server data tools then do the following:
Step 1: On the Windows Start menu, search for and select Visual Studio (SSDT). Best practice is to Run as Administrator.


Step 2: In Visual Studio, select File Ã  New Ã  Project to create a new Integration Services project.



Step 3: In the New Project dialog box, expand the Business Intelligence node under Installed, and select Integration Services Project in the pane on the right side. In the Name box, change the default name to SchoolGunViolenceDatamart. Accept the default location and select OK.


Step 4: By default, an empty package titled Package.dtsx is created and added to your project under SSIS Packages. In Solution Explorer, right-click Package.dtsx, select Rename, and rename the default package to LoadJsonFile.



SQL Server Integration Service (SSIS) is a component of the Microsoft SQL Server database software that can be used to execute a wide range of data migration tasks. SSIS is a fast & flexible data warehousing tool used for data extraction, loading and transformation like cleaning, aggregating, merging data, etc.

https://www.guru99.com/ssis-tutorial.html